from pymysql import *


def main():
    # 创建Connection连接
    conn = connect(host='47.105.98.103', port=3306, user='root', password='root', database='py_study')
    cursor = conn.cursor()
    cursor.execute("select * from goods;")
    print(cursor.fetchone())
    cursor.close()
    conn.close()


if __name__ == '__main__':
    main()
